-
Re: Contact list displays email instead of name
@Phil E Try some of the solutions in this thread, especially the final post if you're seeing 2 user accounts for one person:1 · -
Re: Column Formula to Highlight Rows from the Current Week
@HenryWong You can't make it a column formula because you're specifying an exact cell instead of @row, etc. Your formula should be (and then you can make it a column formula): =IF(WEEKNUMBER([Start D…1 · -
Re: How to do a collect statement against a multi value dropdown?
@srezazadeh97 Here's the first sheet which is basically your database of roles, departments, and softwares: Here's your final sheet with the resolved solution (note: the Training Required column will…1 · -
Re: column symbol to change given certain criteria in a helper column AND if an attachment is not attach
@Amy Slovacek You can use an automation to let your sheet know when an attachment is added to the sheet and do something like recording a date or checking a box. You could set that up and then write …1 · -
Re: "if and" and greater than or equal to
@D.wilson Are you putting a space between the < and the =? You can't do that.1 ·